package com.sky.mapper.courier;

import com.sky.pojo.Courier;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description CourierMapper
 * @Author lyh
 * @Date 2024-10-21
 */
@Mapper
public interface CourierMapper {
    @Select("select * from tb_courier where on_job=1")
    List<Courier> findAllOnJob();

    List<Courier> findCourierByIds(List<Long> courierIds);
    @Select("select * from tb_courier where telephone=#{telephone}")
    Courier getCourierByTel(String telephone);
    @Select("select * from tb_courier where id=#{courierId}")
    Courier getById(Integer courierId);
}
